package com.sdy.usercenter.biz.mapper;

import com.sdy.usercenter.biz.model.SysUser;
import com.sdy.mvc.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 用户基础信息表 Mapper 接口
 * </p>
 *
 * @author zzq
 * @since 2019-06-14
 */
public interface SysUserMapper extends BaseMapper<SysUser> {
    void updateExpireTimeNull(Integer userId);

    Integer pageUserWithRoleCount(Map<String, Object> query);

    List<SysUser> pageUserWithRole(Map<String, Object> query);

    Integer pageUserWithoutRoleCount(Map<String, Object> query);

    List<SysUser> pageUserWithoutRole(Map<String, Object> query);

    Integer pageUserWithAppCount(Map<String, Object> query);

    List<SysUser> pageUserWithApp(Map<String, Object> query);

    Integer pageUserWithoutAppCount(Map<String, Object> query);

    List<SysUser> pageUserWithoutApp(Map<String, Object> query);

    Integer pageUserInDeptCount(Map<String, Object> query);
    
    List<SysUser> pageUserInDept(Map<String, Object> query);

    Integer pageUserInDeptRCount(Map<String, Object> query);

    List<SysUser> pageUserInDeptR(Map<String, Object> query);
}
